﻿<cfsilent>
	
	<cfset jsonAdvice = getProperty("serviceFactory").getBean("jsonAdvice") />
	<cfset response = structNew() />

	<cftransaction>
        <cfset sql =  "DELETE FROM t_subject a  
					   WHERE a.sbj_id = :SubjectID "/>
                       
        <cfset queryObj = new query( datasource=application.dnsMaster )/>
        <cfset queryObj.addParam( name="SubjectID", value=event.getArg("SubjectID"), cfsqltype="cf_sql_varchar" )/>
		<cfset queryObj.execute( sql=sql )/>
        
		<cfset structInsert(response, "SubjectID", event.getArg("SubjectID")) />
		
	</cftransaction>

</cfsilent><cfoutput>#jsonAdvice.encode(data:response, stringNumbers:true)#</cfoutput>